CREATE TABLE [dbo].[tb_Organismos]
(
[idOrganismo] [int] NOT NULL IDENTITY(1, 1),
[Descripcion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[tipoOrganismo] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Organismos] ADD CONSTRAINT [PK_tb_Organismos] PRIMARY KEY NONCLUSTERED  ([idOrganismo]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Organismos] WITH NOCHECK ADD CONSTRAINT [FK_tb_Organismos_tb_TipoDeOrganismos] FOREIGN KEY ([tipoOrganismo]) REFERENCES [dbo].[tb_TipoDeOrganismos] ([idTipodeOrganismo])
GO
